
******************************************************************
***  This File imports the childcost data for each state       ***
******************************************************************


* Import the childcost data
import excel "$childcost/AllCosts_forSTATA.xlsx", sheet("Sheet1") firstrow
reshape long icent ifcc yocent yofcc, i(state) j(year)

* Merge with the state id - fips
merge m:1 state using "$childcost/stateinfo.dta"
destring(stateid), replace
egen state_year = concat(year stateid)
drop year state stateid region division _merge
order state_year

save "$temp/childcost_raw.dta", replace

clear


